Education and Services Hub

Course Title:

Course ID:

010424 0770 1335ESH

Course Dates :

01/Apr/2024

 To

05/Apr/2024

Course Duration :

5

Course Location:

Istanbul

Turkey

Course Fees GBP £ :

Primary Price

£3,177.38

VAT may vary depending on the country where the course or workshop is held

Course Fees USD $:

Advisory Price

$3,950.00

VAT may vary depending on the country where the course or workshop is held

Course Category:

NGO Programmes

Artificial Intelligence (NT)

Course Certified By:

* Professional Training and CPD Programs
* Executive Diploma Certificate
* Executive Masters Certificate

* ESHub CPD
* LondonUni
* Others

United Kingdom

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Course Information

Introduction

Welcome to the "Data Management and Analysis using Excel Course" designed specifically for NGOs. In today's data-driven world, effective management and analysis of data are crucial for NGOs to make informed decisions, improve operations, and demonstrate impact.
This comprehensive five-day course will equip participants with essential Excel skills tailored to the unique needs of non-profit organizations.
Through hands-on exercises and practical examples, attendees will learn how to efficiently manage, analyse, and visualize data using Excel, empowering them to leverage data for better decision-making and organizational success.
This comprehensive five-day course will provide participants with the essential Excel skills and knowledge needed to effectively manage and analyse data within the context of non-profit organizations.

Objectives

• Equip participants with foundational Excel skills for data management and analysis.
• Provide practical knowledge and techniques tailored to the needs of NGOs.
• Enable participants to effectively organize, clean, and manipulate data in Excel.
• Teach participants how to perform basic and advanced data analysis using Excel.
• Empower participants to create impactful visualizations to communicate data insights effectively.

Who Should Attend?

This course is designed for professionals working in non-profit organizations who are involved in data management, analysis, reporting, or decision-making roles.
It is suitable for individuals at all levels of expertise, from beginners to intermediate Excel users, who want to enhance their data skills within the context of NGO operations.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
• Post-assessment

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

The course agenda will be as follows:
• Technical Session 08.30-10.00 am
• Coffee Break 10.00-10.15 am
• Technical Session 10.15-12.15 noon
• Coffee Break 12.15-12.45 pm
• Technical Session 12.45-02.30 pm
• Course Ends 02.30 pm

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Week 1

Day 1:
Excel Fundamentals for Data Management
• Introduction to Excel interface and basic functions
• Data entry and formatting best practices
• Sorting and filtering data
• Introduction to data validation and cleaning techniques

Day 2:
Advanced Data Manipulation in Excel
• Working with advanced functions: IF, VLOOKUP, INDEX/MATCH
• Text functions for data manipulation
• Introduction to pivot tables for data summarization
• Techniques for data deduplication and data cleansing

Day 3:
Data Analysis Techniques in Excel
• Understanding statistical functions in Excel
• Introduction to descriptive statistics and data visualization
• Performing basic data analysis: mean, median, mode, standard deviation
• Using Excel's built-in analysis tools for trend analysis and forecasting

Day 4:
Advanced Data Analysis and Visualization
• Introduction to advanced chart types and customization
• Creating dynamic dashboards in Excel
• Performing regression analysis in Excel
• Introduction to Power Query for data transformation and integration

Day 5:
Practical Applications and Case Studies
• Applying Excel skills to real-world NGO scenarios
• Case studies and hands-on exercises
• Tips for effective data presentation and storytelling
• Q&A session and course wrap-up

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.